﻿CREATE TABLE [dbo].[tblMonitor_ServerRoleMembers] (
	[srm_id] INT IDENTITY(1, 1) NOT NULL,
	[srm_role_name] VARCHAR(128) NOT NULL,
	[srm_member_name] VARCHAR(512) NOT NULL,
	[srm_member_type] CHAR(1) NOT NULL,
	[srm_databasename] VARCHAR(256) NULL,
	[srm_member_disabled] BIT NOT NULL CONSTRAINT [DF_tblMonitor_ServerRoleMembers_Disabled] DEFAULT (0),
	[srm_start_date] DATETIME NOT NULL CONSTRAINT [DF_tblMonitor_ServerRoleMembers_StartDate] DEFAULT(GETDATE()),
	[srm_end_date] DATETIME NULL,
	CONSTRAINT [PK_tblMonitor_ServerRoleMembers] PRIMARY KEY ([srm_id])
	)
